Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 1000 |
| Missing cells | 5308 |
| Missing cells (%) | 22.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 368.6 KiB |
| Average record size in memory | 377.4 B |
Variable types
| NUM | 18 |
|---|---|
| CAT | 3 |
| UNSUPPORTED | 2 |
| DATE | 1 |
Reproduction
| Analysis started | 2020-04-04 15:19:34.444816 |
|---|---|
| Analysis finished | 2020-04-04 15:20:46.873167 |
| Version | pandas-profiling v2.5.3 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Haltestelle has a high cardinality: 366 distinct values | High cardinality |
Nachste_Haltestelle has a high cardinality: 373 distinct values | High cardinality |
Tage_DWV is highly correlated with Tage_DTV | High Correlation |
Tage_DTV is highly correlated with Tage_DWV and 2 other fields | High Correlation |
Tage_SA is highly correlated with Tage_DTV | High Correlation |
Tage_SO is highly correlated with Tage_DTV | High Correlation |
Durchschnitt_Wochentag is highly correlated with Durchschnitt_Tag | High Correlation |
Durchschnitt_Tag is highly correlated with Durchschnitt_Wochentag and 2 other fields | High Correlation |
Durchschnitt_Samstag is highly correlated with Durchschnitt_Tag | High Correlation |
Durchschnitt_Sonntag is highly correlated with Besetzung and 1 other fields | High Correlation |
Besetzung is highly correlated with Durchschnitt_Sonntag | High Correlation |
Uhrzeit has 29 (2.9%) missing values | Missing |
Anzahl_Messungen has 111 (11.1%) missing values | Missing |
Einsteiger has 93 (9.3%) missing values | Missing |
Aussteiger has 132 (13.2%) missing values | Missing |
Tage_DTV has 207 (20.7%) missing values | Missing |
Tage_DWV has 553 (55.3%) missing values | Missing |
Tage_SA has 797 (79.7%) missing values | Missing |
Tage_SO has 865 (86.5%) missing values | Missing |
Haltestelle has 23 (2.3%) missing values | Missing |
Haltestelle_Nummer has 23 (2.3%) missing values | Missing |
Nachste_Haltestelle has 23 (2.3%) missing values | Missing |
Nachste_Haltestelle_Nummer has 23 (2.3%) missing values | Missing |
Durchschnitt_Tag has 209 (20.9%) missing values | Missing |
Durchschnitt_Wochentag has 554 (55.4%) missing values | Missing |
Durchschnitt_Samstag has 797 (79.7%) missing values | Missing |
Durchschnitt_Sonntag has 866 (86.6%) missing values | Missing |
Haltestelle_Id is an unsupported type, check if it needs cleaning or further analysis | Rejected |
Nachste_Haltestelle_Id is an unsupported type, check if it needs cleaning or further analysis | Rejected |
df_index
Real number (ℝ≥0)
| Distinct count | 995 |
|---|---|
| Unique (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48687.227 |
|---|---|
| Minimum | 391 |
| Maximum | 99833 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 391 |
|---|---|
| 5-th percentile | 4484.55 |
| Q1 | 23903.75 |
| median | 46963 |
| Q3 | 74761 |
| 95-th percentile | 94277.1 |
| Maximum | 99833 |
| Range | 99442 |
| Interquartile range (IQR) | 50857.25 |
Descriptive statistics
| Standard deviation | 28690.08213 |
|---|---|
| Coefficient of variation (CV) | 0.5892732837 |
| Kurtosis | -1.173282813 |
| Mean | 48687.227 |
| Median Absolute Deviation (MAD) | 24659.61717 |
| Skewness | 0.07697102401 |
| Sum | 48687227 |
| Variance | 823120812.4 |
| Value | Count | Frequency (%) | |
| 11421 | 2 | 0.2% | |
| 8322 | 2 | 0.2% | |
| 86181 | 2 | 0.2% | |
| 53982 | 2 | 0.2% | |
| 2845 | 2 | 0.2% | |
| 18429 | 1 | 0.1% | |
| 21178 | 1 | 0.1% | |
| 60157 | 1 | 0.1% | |
| 92743 | 1 | 0.1% | |
| 88761 | 1 | 0.1% | |
| Other values (985) | 985 | 98.5% |
| Value | Count | Frequency (%) | |
| 391 | 1 | 0.1% | |
| 424 | 1 | 0.1% | |
| 493 | 1 | 0.1% | |
| 683 | 1 | 0.1% | |
| 723 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 99833 | 1 | 0.1% | |
| 99780 | 1 | 0.1% | |
| 99732 | 1 | 0.1% | |
| 99614 | 1 | 0.1% | |
| 99460 | 1 | 0.1% |
Linie
Real number (ℝ≥0)
| Distinct count | 72 |
|---|---|
| Unique (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.026 |
|---|---|
| Minimum | 2 |
| Maximum | 916 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 70 |
| 95-th percentile | 412 |
| Maximum | 916 |
| Range | 914 |
| Interquartile range (IQR) | 62 |
Descriptive statistics
| Standard deviation | 163.1348899 |
|---|---|
| Coefficient of variation (CV) | 1.964865102 |
| Kurtosis | 9.756250566 |
| Mean | 83.026 |
| Median Absolute Deviation (MAD) | 99.901732 |
| Skewness | 3.047404826 |
| Sum | 83026 |
| Variance | 26612.99232 |
| Value | Count | Frequency (%) | |
| 2 | 86 | 8.6% | |
| 6 | 56 | 5.6% | |
| 32 | 55 | 5.5% | |
| 8 | 55 | 5.5% | |
| 9 | 54 | 5.4% | |
| 31 | 49 | 4.9% | |
| 10 | 48 | 4.8% | |
| 13 | 44 | 4.4% | |
| 3 | 36 | 3.6% | |
| 80 | 35 | 3.5% | |
| Other values (62) | 482 | 48.2% |
| Value | Count | Frequency (%) | |
| 2 | 86 | 8.6% | |
| 3 | 36 | 3.6% | |
| 4 | 35 | 3.5% | |
| 5 | 11 | 1.1% | |
| 6 | 56 | 5.6% |
| Value | Count | Frequency (%) | |
| 916 | 3 | 0.3% | |
| 912 | 4 | 0.4% | |
| 910 | 3 | 0.3% | |
| 751 | 5 | 0.5% | |
| 744 | 1 | 0.1% |
Richtung
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 2 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 2 | 522 | 52.2% | |
| 1 | 478 | 47.8% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
Anzahl_Haltestellen
Real number (ℝ≥0)
| Distinct count | 32 |
|---|---|
| Unique (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.847 |
|---|---|
| Minimum | 1 |
| Maximum | 32 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 11 |
| Q3 | 17 |
| 95-th percentile | 26 |
| Maximum | 32 |
| Range | 31 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.69446527 |
|---|---|
| Coefficient of variation (CV) | 0.6494863907 |
| Kurtosis | -0.5655770748 |
| Mean | 11.847 |
| Median Absolute Deviation (MAD) | 6.382924 |
| Skewness | 0.5558555147 |
| Sum | 11847 |
| Variance | 59.2047958 |
| Value | Count | Frequency (%) | |
| 4 | 58 | 5.8% | |
| 2 | 57 | 5.7% | |
| 8 | 56 | 5.6% | |
| 10 | 54 | 5.4% | |
| 5 | 53 | 5.3% | |
| 9 | 49 | 4.9% | |
| 11 | 49 | 4.9% | |
| 1 | 47 | 4.7% | |
| 6 | 46 | 4.6% | |
| 13 | 45 | 4.5% | |
| Other values (22) | 486 | 48.6% |
| Value | Count | Frequency (%) | |
| 1 | 47 | 4.7% | |
| 2 | 57 | 5.7% | |
| 3 | 41 | 4.1% | |
| 4 | 58 | 5.8% | |
| 5 | 53 | 5.3% |
| Value | Count | Frequency (%) | |
| 32 | 1 | 0.1% | |
| 31 | 7 | 0.7% | |
| 30 | 9 | 0.9% | |
| 29 | 10 | 1.0% | |
| 28 | 10 | 1.0% |
| Distinct count | 933 |
|---|---|
| Unique (%) | 96.1% |
| Missing | 29 |
| Missing (%) | 2.9% |
| Memory size | 7.9 KiB |
| Minimum | 1900-01-01 04:54:24 |
|---|---|
| Maximum | 1900-01-01 23:59:48 |
| Distinct count | 77 |
|---|---|
| Unique (%) | 8.7% |
| Missing | 111 |
| Missing (%) | 11.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.28121485 |
|---|---|
| Minimum | 1 |
| Maximum | 116 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 15 |
| 95-th percentile | 46.6 |
| Maximum | 116 |
| Range | 115 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 16.16105931 |
|---|---|
| Coefficient of variation (CV) | 1.216835922 |
| Kurtosis | 8.130025064 |
| Mean | 13.28121485 |
| Median Absolute Deviation (MAD) | 10.71732878 |
| Skewness | 2.620768429 |
| Sum | 11807 |
| Variance | 261.1798382 |
| Value | Count | Frequency (%) | |
| 1 | 80 | 8.0% | |
| 2 | 76 | 7.6% | |
| 4 | 64 | 6.4% | |
| 3 | 59 | 5.9% | |
| 6 | 58 | 5.8% | |
| 5 | 49 | 4.9% | |
| 7 | 44 | 4.4% | |
| 10 | 44 | 4.4% | |
| 8 | 38 | 3.8% | |
| 9 | 37 | 3.7% | |
| Other values (67) | 340 | 34.0% | |
| (Missing) | 111 | 11.1% |
| Value | Count | Frequency (%) | |
| 1 | 80 | 8.0% | |
| 2 | 76 | 7.6% | |
| 3 | 59 | 5.9% | |
| 4 | 64 | 6.4% | |
| 5 | 49 | 4.9% |
| Value | Count | Frequency (%) | |
| 116 | 1 | 0.1% | |
| 102 | 1 | 0.1% | |
| 97 | 1 | 0.1% | |
| 91 | 1 | 0.1% | |
| 89 | 1 | 0.1% |
| Distinct count | 431 |
|---|---|
| Unique (%) | 47.5% |
| Missing | 93 |
| Missing (%) | 9.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.610423565 |
|---|---|
| Minimum | 0.009999999776 |
| Maximum | 75.37000275 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.009999999776 |
|---|---|
| 5-th percentile | 0.2300000042 |
| Q1 | 1 |
| median | 2.779999971 |
| Q3 | 6.670000076 |
| 95-th percentile | 21.13399887 |
| Maximum | 75.37000275 |
| Range | 75.36000275 |
| Interquartile range (IQR) | 5.670000076 |
Descriptive statistics
| Standard deviation | 7.625798702 |
|---|---|
| Coefficient of variation (CV) | 1.359219783 |
| Kurtosis | 13.60228825 |
| Mean | 5.610423565 |
| Median Absolute Deviation (MAD) | 5.090398312 |
| Skewness | 3.01630497 |
| Sum | 5088.649902 |
| Variance | 58.15280533 |
| Value | Count | Frequency (%) | |
| 1 | 46 | 4.6% | |
| 2 | 29 | 2.9% | |
| 0.5 | 21 | 2.1% | |
| 4 | 20 | 2.0% | |
| 5 | 19 | 1.9% | |
| 3.5 | 16 | 1.6% | |
| 3 | 11 | 1.1% | |
| 1.330000043 | 11 | 1.1% | |
| 1.5 | 10 | 1.0% | |
| 0.6600000262 | 10 | 1.0% | |
| Other values (421) | 714 | 71.4% | |
| (Missing) | 93 | 9.3% |
| Value | Count | Frequency (%) | |
| 0.009999999776 | 2 | 0.2% | |
| 0.02999999933 | 1 | 0.1% | |
| 0.05000000075 | 3 | 0.3% | |
| 0.05999999866 | 3 | 0.3% | |
| 0.0700000003 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 75.37000275 | 1 | 0.1% | |
| 49.91999817 | 1 | 0.1% | |
| 48.20000076 | 1 | 0.1% | |
| 41.33000183 | 1 | 0.1% | |
| 40.5 | 1 | 0.1% |
| Distinct count | 406 |
|---|---|
| Unique (%) | 46.8% |
| Missing | 132 |
| Missing (%) | 13.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.168573856 |
|---|---|
| Minimum | 0.009999999776 |
| Maximum | 80.97000122 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.009999999776 |
|---|---|
| 5-th percentile | 0.1934999973 |
| Q1 | 1 |
| median | 2.644999981 |
| Q3 | 6.882499695 |
| 95-th percentile | 18 |
| Maximum | 80.97000122 |
| Range | 80.96000122 |
| Interquartile range (IQR) | 5.882499695 |
Descriptive statistics
| Standard deviation | 6.763618469 |
|---|---|
| Coefficient of variation (CV) | 1.308604396 |
| Kurtosis | 23.90267372 |
| Mean | 5.168573856 |
| Median Absolute Deviation (MAD) | 4.578095436 |
| Skewness | 3.538320065 |
| Sum | 4486.320312 |
| Variance | 45.74653244 |
| Value | Count | Frequency (%) | |
| 1 | 36 | 3.6% | |
| 2 | 33 | 3.3% | |
| 0.5 | 23 | 2.3% | |
| 4 | 19 | 1.9% | |
| 1.5 | 13 | 1.3% | |
| 3 | 13 | 1.3% | |
| 6 | 12 | 1.2% | |
| 0.6600000262 | 12 | 1.2% | |
| 0.3300000131 | 11 | 1.1% | |
| 1.25 | 10 | 1.0% | |
| Other values (396) | 686 | 68.6% | |
| (Missing) | 132 | 13.2% |
| Value | Count | Frequency (%) | |
| 0.009999999776 | 2 | 0.2% | |
| 0.01999999955 | 1 | 0.1% | |
| 0.02999999933 | 1 | 0.1% | |
| 0.05000000075 | 4 | 0.4% | |
| 0.05999999866 | 4 | 0.4% |
| Value | Count | Frequency (%) | |
| 80.97000122 | 1 | 0.1% | |
| 54.36999893 | 1 | 0.1% | |
| 42 | 1 | 0.1% | |
| 38.59999847 | 1 | 0.1% | |
| 34 | 1 | 0.1% |
| Distinct count | 712 |
|---|---|
| Unique (%) | 71.4% |
| Missing | 3 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.33268547 |
|---|---|
| Minimum | 0.09000000358 |
| Maximum | 209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.09000000358 |
|---|---|
| 5-th percentile | 2.177999973 |
| Q1 | 9.25 |
| median | 20.25 |
| Q3 | 37.06999969 |
| 95-th percentile | 74.6780014 |
| Maximum | 209 |
| Range | 208.91 |
| Interquartile range (IQR) | 27.81999969 |
Descriptive statistics
| Standard deviation | 25.69221115 |
|---|---|
| Coefficient of variation (CV) | 0.9399812243 |
| Kurtosis | 6.917271137 |
| Mean | 27.33268547 |
| Median Absolute Deviation (MAD) | 18.50615883 |
| Skewness | 2.121451616 |
| Sum | 27250.68945 |
| Variance | 660.0897217 |
| Value | Count | Frequency (%) | |
| 4 | 11 | 1.1% | |
| 6 | 10 | 1.0% | |
| 2 | 8 | 0.8% | |
| 8 | 8 | 0.8% | |
| 20 | 8 | 0.8% | |
| 11 | 8 | 0.8% | |
| 9.5 | 7 | 0.7% | |
| 15 | 7 | 0.7% | |
| 28 | 7 | 0.7% | |
| 13 | 6 | 0.6% | |
| Other values (702) | 917 | 91.7% |
| Value | Count | Frequency (%) | |
| 0.09000000358 | 1 | 0.1% | |
| 0.25 | 1 | 0.1% | |
| 0.400000006 | 1 | 0.1% | |
| 0.5 | 3 | 0.3% | |
| 0.6100000143 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 209 | 1 | 0.1% | |
| 190.6600037 | 1 | 0.1% | |
| 147.25 | 1 | 0.1% | |
| 147 | 1 | 0.1% | |
| 142 | 1 | 0.1% |
Distanz
Real number (ℝ≥0)
| Distinct count | 355 |
|---|---|
| Unique (%) | 35.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 409.5480042 |
|---|---|
| Minimum | 108 |
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 108 |
|---|---|
| 5-th percentile | 213 |
| Q1 | 297.75 |
| median | 370 |
| Q3 | 464 |
| 95-th percentile | 683.05 |
| Maximum | 2020 |
| Range | 1912 |
| Interquartile range (IQR) | 166.25 |
Descriptive statistics
| Standard deviation | 187.7185364 |
|---|---|
| Coefficient of variation (CV) | 0.458355393 |
| Kurtosis | 14.15157413 |
| Mean | 409.5480042 |
| Median Absolute Deviation (MAD) | 122.5026016 |
| Skewness | 2.893883705 |
| Sum | 409548 |
| Variance | 35238.24609 |
| Value | Count | Frequency (%) | |
| 280 | 12 | 1.2% | |
| 341 | 11 | 1.1% | |
| 380 | 10 | 1.0% | |
| 370 | 10 | 1.0% | |
| 320 | 10 | 1.0% | |
| 420 | 10 | 1.0% | |
| 213 | 10 | 1.0% | |
| 268 | 10 | 1.0% | |
| 272 | 10 | 1.0% | |
| 397 | 9 | 0.9% | |
| Other values (345) | 898 | 89.8% |
| Value | Count | Frequency (%) | |
| 108 | 1 | 0.1% | |
| 118 | 2 | 0.2% | |
| 131 | 1 | 0.1% | |
| 132 | 1 | 0.1% | |
| 135 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 2020 | 1 | 0.1% | |
| 1664 | 1 | 0.1% | |
| 1613 | 1 | 0.1% | |
| 1595 | 1 | 0.1% | |
| 1457 | 1 | 0.1% |
| Distinct count | 53 |
|---|---|
| Unique (%) | 6.7% |
| Missing | 207 |
| Missing (%) | 20.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 81.31509399 |
|---|---|
| Minimum | 10.14999962 |
| Maximum | 251 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 10.14999962 |
|---|---|
| 5-th percentile | 14.71000004 |
| Q1 | 37.27999878 |
| median | 52 |
| Q3 | 87 |
| 95-th percentile | 251 |
| Maximum | 251 |
| Range | 240.8500004 |
| Interquartile range (IQR) | 49.72000122 |
Descriptive statistics
| Standard deviation | 69.93824005 |
|---|---|
| Coefficient of variation (CV) | 0.8600892727 |
| Kurtosis | 0.3493234217 |
| Mean | 81.31509399 |
| Median Absolute Deviation (MAD) | 55.41399384 |
| Skewness | 1.31481123 |
| Sum | 64482.85938 |
| Variance | 4891.357422 |
| Value | Count | Frequency (%) | |
| 52 | 107 | 10.7% | |
| 62 | 95 | 9.5% | |
| 48 | 90 | 9.0% | |
| 203 | 76 | 7.6% | |
| 251 | 50 | 5.0% | |
| 27.69000053 | 23 | 2.3% | |
| 87 | 19 | 1.9% | |
| 14.71000004 | 19 | 1.9% | |
| 37.27999878 | 17 | 1.7% | |
| 77.56999969 | 16 | 1.6% | |
| Other values (43) | 281 | 28.1% | |
| (Missing) | 207 | 20.7% |
| Value | Count | Frequency (%) | |
| 10.14999962 | 4 | 0.4% | |
| 10.78999996 | 6 | 0.6% | |
| 13.72000027 | 2 | 0.2% | |
| 13.77000046 | 7 | 0.7% | |
| 13.84000015 | 9 | 0.9% |
| Value | Count | Frequency (%) | |
| 251 | 50 | 5.0% | |
| 203 | 76 | 7.6% | |
| 183 | 3 | 0.3% | |
| 177.1699982 | 14 | 1.4% | |
| 168.3099976 | 3 | 0.3% |
| Distinct count | 32 |
|---|---|
| Unique (%) | 7.2% |
| Missing | 553 |
| Missing (%) | 55.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.5014038 |
|---|---|
| Minimum | 10.14999962 |
| Maximum | 251 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 10.14999962 |
|---|---|
| 5-th percentile | 18.29000092 |
| Q1 | 48 |
| median | 77.56999969 |
| Q3 | 203 |
| 95-th percentile | 251 |
| Maximum | 251 |
| Range | 240.8500004 |
| Interquartile range (IQR) | 155 |
Descriptive statistics
| Standard deviation | 81.57498169 |
|---|---|
| Coefficient of variation (CV) | 0.7449674511 |
| Kurtosis | -1.30383563 |
| Mean | 109.5014038 |
| Median Absolute Deviation (MAD) | 73.60659027 |
| Skewness | 0.5069775581 |
| Sum | 48947.125 |
| Variance | 6654.478027 |
| Value | Count | Frequency (%) | |
| 48 | 88 | 8.8% | |
| 203 | 76 | 7.6% | |
| 251 | 50 | 5.0% | |
| 27.69000053 | 23 | 2.3% | |
| 87 | 19 | 1.9% | |
| 77.56999969 | 16 | 1.6% | |
| 24.70000076 | 15 | 1.5% | |
| 177.1699982 | 14 | 1.4% | |
| 18.29000092 | 13 | 1.3% | |
| 25 | 13 | 1.3% | |
| Other values (22) | 120 | 12.0% | |
| (Missing) | 553 | 55.3% |
| Value | Count | Frequency (%) | |
| 10.14999962 | 4 | 0.4% | |
| 13.72000027 | 2 | 0.2% | |
| 13.84000015 | 9 | 0.9% | |
| 18.29000092 | 13 | 1.3% | |
| 20.29999924 | 6 | 0.6% |
| Value | Count | Frequency (%) | |
| 251 | 50 | 5.0% | |
| 203 | 76 | 7.6% | |
| 183 | 3 | 0.3% | |
| 177.1699982 | 14 | 1.4% | |
| 168.3099976 | 3 | 0.3% |
| Distinct count | 12 |
|---|---|
| Unique (%) | 5.9% |
| Missing | 797 |
| Missing (%) | 79.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.81355286 |
|---|---|
| Minimum | 10.78999996 |
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 10.78999996 |
|---|---|
| 5-th percentile | 14.71000004 |
| Q1 | 22.55999947 |
| median | 41.20000076 |
| Q3 | 52 |
| 95-th percentile | 52 |
| Maximum | 52 |
| Range | 41.21000004 |
| Interquartile range (IQR) | 29.44000053 |
Descriptive statistics
| Standard deviation | 14.61869144 |
|---|---|
| Coefficient of variation (CV) | 0.3766388379 |
| Kurtosis | -1.273086548 |
| Mean | 38.81355286 |
| Median Absolute Deviation (MAD) | 13.07326984 |
| Skewness | -0.5355802178 |
| Sum | 7879.149902 |
| Variance | 213.7061462 |
| Value | Count | Frequency (%) | |
| 52 | 99 | 9.9% | |
| 14.71000004 | 19 | 1.9% | |
| 37.27999878 | 17 | 1.7% | |
| 20.60000038 | 15 | 1.5% | |
| 31.38999939 | 9 | 0.9% | |
| 41.20000076 | 9 | 0.9% | |
| 22.55999947 | 8 | 0.8% | |
| 29.43000031 | 7 | 0.7% | |
| 10.78999996 | 6 | 0.6% | |
| 30.40999985 | 6 | 0.6% | |
| Other values (2) | 8 | 0.8% | |
| (Missing) | 797 | 79.7% |
| Value | Count | Frequency (%) | |
| 10.78999996 | 6 | 0.6% | |
| 14.71000004 | 19 | 1.9% | |
| 20.60000038 | 15 | 1.5% | |
| 21.57999992 | 5 | 0.5% | |
| 22.55999947 | 8 | 0.8% |
| Value | Count | Frequency (%) | |
| 52 | 99 | 9.9% | |
| 41.20000076 | 9 | 0.9% | |
| 38 | 3 | 0.3% | |
| 37.27999878 | 17 | 1.7% | |
| 31.38999939 | 9 | 0.9% |
| Distinct count | 10 |
|---|---|
| Unique (%) | 7.4% |
| Missing | 865 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53.63392639 |
|---|---|
| Minimum | 13.77000046 |
| Maximum | 62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 13.77000046 |
|---|---|
| 5-th percentile | 15.14900017 |
| Q1 | 48.22000122 |
| median | 62 |
| Q3 | 62 |
| 95-th percentile | 62 |
| Maximum | 62 |
| Range | 48.22999954 |
| Interquartile range (IQR) | 13.77999878 |
Descriptive statistics
| Standard deviation | 15.14799213 |
|---|---|
| Coefficient of variation (CV) | 0.2824330261 |
| Kurtosis | 1.601834059 |
| Mean | 53.63392639 |
| Median Absolute Deviation (MAD) | 11.77448273 |
| Skewness | -1.720984936 |
| Sum | 7240.580078 |
| Variance | 229.4616699 |
| Value | Count | Frequency (%) | |
| 62 | 95 | 9.5% | |
| 48.22000122 | 11 | 1.1% | |
| 13.77000046 | 7 | 0.7% | |
| 40.34000015 | 5 | 0.5% | |
| 21.64999962 | 4 | 0.4% | |
| 46.25 | 4 | 0.4% | |
| 15.73999977 | 3 | 0.3% | |
| 22.62999916 | 3 | 0.3% | |
| 48 | 2 | 0.2% | |
| 39.36000061 | 1 | 0.1% | |
| (Missing) | 865 | 86.5% |
| Value | Count | Frequency (%) | |
| 13.77000046 | 7 | 0.7% | |
| 15.73999977 | 3 | 0.3% | |
| 21.64999962 | 4 | 0.4% | |
| 22.62999916 | 3 | 0.3% | |
| 39.36000061 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 62 | 95 | 9.5% | |
| 48.22000122 | 11 | 1.1% | |
| 48 | 2 | 0.2% | |
| 46.25 | 4 | 0.4% | |
| 40.34000015 | 5 | 0.5% |
| Distinct count | 366 |
|---|---|
| Unique (%) | 37.5% |
| Missing | 23 |
| Missing (%) | 2.3% |
| Memory size | 7.9 KiB |
| Zürich, Kantonalbank | 16 |
|---|---|
| Zürich, Limmatplatz | 15 |
| Zürich, Bellevue | 15 |
| Zürich, Paradeplatz | 15 |
| Zürich, Albisriederplatz | 11 |
| Other values (361) |
| Value | Count | Frequency (%) | |
| Zürich, Kantonalbank | 16 | 1.6% | |
| Zürich, Limmatplatz | 15 | 1.5% | |
| Zürich, Bellevue | 15 | 1.5% | |
| Zürich, Paradeplatz | 15 | 1.5% | |
| Zürich, Albisriederplatz | 11 | 1.1% | |
| Zürich, Stauffacher | 11 | 1.1% | |
| Zürich, Stockerstrasse | 10 | 1.0% | |
| Zürich, Haldenegg | 10 | 1.0% | |
| Zürich, Bucheggplatz | 9 | 0.9% | |
| Zürich, Bändliweg | 8 | 0.8% | |
| Other values (356) | 857 | 85.7% | |
| (Missing) | 23 | 2.3% |
Length
| Max length | 30 |
|---|---|
| Mean length | 20.503 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 29 | 48.3% | |
| Uppercase_Letter | 24 | 40.0% | |
| Other_Punctuation | 3 | 5.0% | |
| Dash_Punctuation | 1 | 1.7% | |
| Open_Punctuation | 1 | 1.7% | |
| Close_Punctuation | 1 | 1.7% | |
| Space_Separator | 1 | 1.7% |
| Value | Count | Frequency (%) | |
| Latin | 53 | 88.3% | |
| Common | 7 | 11.7% |
| Value | Count | Frequency (%) | |
| ASCII | 57 | 100.0% |
| Distinct count | 366 |
|---|---|
| Unique (%) | 37.5% |
| Missing | 23 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2001.911975 |
|---|---|
| Minimum | 7 |
| Maximum | 12543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 439 |
| Q1 | 1076 |
| median | 1612 |
| Q3 | 2596 |
| 95-th percentile | 4031.4 |
| Maximum | 12543 |
| Range | 12536 |
| Interquartile range (IQR) | 1520 |
Descriptive statistics
| Standard deviation | 1579.662272 |
|---|---|
| Coefficient of variation (CV) | 0.7890767883 |
| Kurtosis | 14.02993666 |
| Mean | 2001.911975 |
| Median Absolute Deviation (MAD) | 1046.198686 |
| Skewness | 2.925086401 |
| Sum | 1955868 |
| Variance | 2495332.894 |
| Value | Count | Frequency (%) | |
| 601 | 16 | 1.6% | |
| 1861 | 15 | 1.5% | |
| 440 | 15 | 1.5% | |
| 1557 | 15 | 1.5% | |
| 48 | 11 | 1.1% | |
| 2556 | 11 | 1.1% | |
| 1100 | 10 | 1.0% | |
| 2582 | 10 | 1.0% | |
| 564 | 9 | 0.9% | |
| 619 | 8 | 0.8% | |
| Other values (356) | 857 | 85.7% | |
| (Missing) | 23 | 2.3% |
| Value | Count | Frequency (%) | |
| 7 | 1 | 0.1% | |
| 46 | 1 | 0.1% | |
| 47 | 2 | 0.2% | |
| 48 | 11 | 1.1% | |
| 67 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 12543 | 1 | 0.1% | |
| 12509 | 1 | 0.1% | |
| 12506 | 1 | 0.1% | |
| 12504 | 1 | 0.1% | |
| 12500 | 1 | 0.1% |
| Distinct count | 373 |
|---|---|
| Unique (%) | 38.2% |
| Missing | 23 |
| Missing (%) | 2.3% |
| Memory size | 7.9 KiB |
| Zürich, Central | 17 |
|---|---|
| Zürich, Bürkliplatz | 14 |
| Zürich, Paradeplatz | 12 |
| Zürich, Helvetiaplatz | 11 |
| Zürich, Museum für Gestaltung | 11 |
| Other values (368) |
| Value | Count | Frequency (%) | |
| Zürich, Central | 17 | 1.7% | |
| Zürich, Bürkliplatz | 14 | 1.4% | |
| Zürich, Paradeplatz | 12 | 1.2% | |
| Zürich, Helvetiaplatz | 11 | 1.1% | |
| Zürich, Museum für Gestaltung | 11 | 1.1% | |
| Zürich, Escher-Wyss-Platz | 10 | 1.0% | |
| Schlieren, Mülligen | 9 | 0.9% | |
| Zürich, Kreuzplatz | 9 | 0.9% | |
| Zürich, Sternen Oerlikon | 9 | 0.9% | |
| Zürich, Bellevue | 8 | 0.8% | |
| Other values (363) | 867 | 86.7% | |
| (Missing) | 23 | 2.3% |
Length
| Max length | 30 |
|---|---|
| Mean length | 20.47 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 29 | 50.9% | |
| Uppercase_Letter | 23 | 40.4% | |
| Other_Punctuation | 3 | 5.3% | |
| Space_Separator | 1 | 1.8% | |
| Dash_Punctuation | 1 | 1.8% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 91.2% | |
| Common | 5 | 8.8% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 373 |
|---|---|
| Unique (%) | 38.2% |
| Missing | 23 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2039.640737 |
|---|---|
| Minimum | 4 |
| Maximum | 12826 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 435 |
| Q1 | 1041 |
| median | 1690 |
| Q3 | 2666 |
| 95-th percentile | 4057.8 |
| Maximum | 12826 |
| Range | 12822 |
| Interquartile range (IQR) | 1625 |
Descriptive statistics
| Standard deviation | 1586.547229 |
|---|---|
| Coefficient of variation (CV) | 0.7778562176 |
| Kurtosis | 13.64196926 |
| Mean | 2039.640737 |
| Median Absolute Deviation (MAD) | 1047.565635 |
| Skewness | 2.866873536 |
| Sum | 1992729 |
| Variance | 2517132.11 |
| Value | Count | Frequency (%) | |
| 619 | 17 | 1.7% | |
| 615 | 14 | 1.4% | |
| 1861 | 12 | 1.2% | |
| 1158 | 11 | 1.1% | |
| 1667 | 11 | 1.1% | |
| 799 | 10 | 1.0% | |
| 1453 | 9 | 0.9% | |
| 1690 | 9 | 0.9% | |
| 2572 | 9 | 0.9% | |
| 3019 | 8 | 0.8% | |
| Other values (363) | 867 | 86.7% | |
| (Missing) | 23 | 2.3% |
| Value | Count | Frequency (%) | |
| 4 | 3 | 0.3% | |
| 7 | 2 | 0.2% | |
| 46 | 2 | 0.2% | |
| 47 | 3 | 0.3% | |
| 48 | 7 | 0.7% |
| Value | Count | Frequency (%) | |
| 12826 | 1 | 0.1% | |
| 12509 | 1 | 0.1% | |
| 12508 | 2 | 0.2% | |
| 12500 | 1 | 0.1% | |
| 12488 | 1 | 0.1% |
| Distinct count | 769 |
|---|---|
| Unique (%) | 97.2% |
| Missing | 209 |
| Missing (%) | 20.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2003.029663 |
|---|---|
| Minimum | 5.370299816 |
| Maximum | 28468.7207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 5.370299816 |
|---|---|
| 5-th percentile | 97.93984985 |
| Q1 | 424.4949951 |
| median | 969.9749756 |
| Q3 | 2141.616699 |
| 95-th percentile | 7488.740234 |
| Maximum | 28468.7207 |
| Range | 28463.3504 |
| Interquartile range (IQR) | 1717.121704 |
Descriptive statistics
| Standard deviation | 3153.686523 |
|---|---|
| Coefficient of variation (CV) | 1.574458223 |
| Kurtosis | 23.16275787 |
| Mean | 2003.029663 |
| Median Absolute Deviation (MAD) | 1832.152466 |
| Skewness | 4.156374931 |
| Sum | 1584397.125 |
| Variance | 9945739 |
| Value | Count | Frequency (%) | |
| 496 | 2 | 0.2% | |
| 446.5999756 | 2 | 0.2% | |
| 216.3000031 | 2 | 0.2% | |
| 322.3999939 | 2 | 0.2% | |
| 981.2400513 | 2 | 0.2% | |
| 1224 | 2 | 0.2% | |
| 676 | 2 | 0.2% | |
| 589 | 2 | 0.2% | |
| 525 | 2 | 0.2% | |
| 1584 | 2 | 0.2% | |
| Other values (759) | 771 | 77.1% | |
| (Missing) | 209 | 20.9% |
| Value | Count | Frequency (%) | |
| 5.370299816 | 1 | 0.1% | |
| 5.394999981 | 1 | 0.1% | |
| 14.71000004 | 1 | 0.1% | |
| 14.71500015 | 1 | 0.1% | |
| 15.5 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 28468.7207 | 1 | 0.1% | |
| 26294.58984 | 1 | 0.1% | |
| 25795.20898 | 1 | 0.1% | |
| 24833.94141 | 1 | 0.1% | |
| 21836.70898 | 1 | 0.1% |
| Distinct count | 437 |
|---|---|
| Unique (%) | 98.0% |
| Missing | 554 |
| Missing (%) | 55.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2919.291016 |
|---|---|
| Minimum | 5.370299816 |
| Maximum | 28468.7207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 5.370299816 |
|---|---|
| 5-th percentile | 192.7149963 |
| Q1 | 736.3707275 |
| median | 1558.73999 |
| Q3 | 3545.527588 |
| 95-th percentile | 10602.69043 |
| Maximum | 28468.7207 |
| Range | 28463.3504 |
| Interquartile range (IQR) | 2809.15686 |
Descriptive statistics
| Standard deviation | 3906.364746 |
|---|---|
| Coefficient of variation (CV) | 1.338121046 |
| Kurtosis | 13.43975353 |
| Mean | 2919.291016 |
| Median Absolute Deviation (MAD) | 2505.747314 |
| Skewness | 3.210196495 |
| Sum | 1302004.25 |
| Variance | 15259686 |
| Value | Count | Frequency (%) | |
| 384 | 2 | 0.2% | |
| 1423.679932 | 2 | 0.2% | |
| 7056.279785 | 2 | 0.2% | |
| 1224 | 2 | 0.2% | |
| 1656 | 2 | 0.2% | |
| 1584 | 2 | 0.2% | |
| 446.5999756 | 2 | 0.2% | |
| 525 | 2 | 0.2% | |
| 816 | 2 | 0.2% | |
| 1712.624023 | 1 | 0.1% | |
| Other values (427) | 427 | 42.7% | |
| (Missing) | 554 | 55.4% |
| Value | Count | Frequency (%) | |
| 5.370299816 | 1 | 0.1% | |
| 34.61249924 | 1 | 0.1% | |
| 37.05000305 | 1 | 0.1% | |
| 46.40000153 | 1 | 0.1% | |
| 54.87000275 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 28468.7207 | 1 | 0.1% | |
| 26294.58984 | 1 | 0.1% | |
| 25795.20898 | 1 | 0.1% | |
| 24833.94141 | 1 | 0.1% | |
| 21836.70898 | 1 | 0.1% |
| Distinct count | 197 |
|---|---|
| Unique (%) | 97.0% |
| Missing | 797 |
| Missing (%) | 79.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 827.0939331 |
|---|---|
| Minimum | 5.394999981 |
| Maximum | 3856.320312 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 5.394999981 |
|---|---|
| 5-th percentile | 45.80799866 |
| Q1 | 221.0850067 |
| median | 562.585022 |
| Q3 | 1184.727539 |
| 95-th percentile | 2625.999756 |
| Maximum | 3856.320312 |
| Range | 3850.925313 |
| Interquartile range (IQR) | 963.6425323 |
Descriptive statistics
| Standard deviation | 814.5111084 |
|---|---|
| Coefficient of variation (CV) | 0.9847867041 |
| Kurtosis | 2.460825682 |
| Mean | 827.0939331 |
| Median Absolute Deviation (MAD) | 624.994751 |
| Skewness | 1.585248351 |
| Sum | 167900.0625 |
| Variance | 663428.375 |
| Value | Count | Frequency (%) | |
| 216.3000031 | 2 | 0.2% | |
| 329.1600037 | 2 | 0.2% | |
| 824 | 2 | 0.2% | |
| 1456 | 2 | 0.2% | |
| 981.2400513 | 2 | 0.2% | |
| 208 | 2 | 0.2% | |
| 570 | 1 | 0.1% | |
| 3217.23999 | 1 | 0.1% | |
| 1404 | 1 | 0.1% | |
| 554.3474121 | 1 | 0.1% | |
| Other values (187) | 187 | 18.7% | |
| (Missing) | 797 | 79.7% |
| Value | Count | Frequency (%) | |
| 5.394999981 | 1 | 0.1% | |
| 14.71000004 | 1 | 0.1% | |
| 14.71500015 | 1 | 0.1% | |
| 24.71279907 | 1 | 0.1% | |
| 26.91930008 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 3856.320312 | 1 | 0.1% | |
| 3762.719971 | 1 | 0.1% | |
| 3744 | 1 | 0.1% | |
| 3553.160156 | 1 | 0.1% | |
| 3217.23999 | 1 | 0.1% |
| Distinct count | 129 |
|---|---|
| Unique (%) | 96.3% |
| Missing | 866 |
| Missing (%) | 86.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 823.1079712 |
|---|---|
| Minimum | 15.5 |
| Maximum | 4053.559814 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 15.5 |
|---|---|
| 5-th percentile | 87.92115021 |
| Q1 | 313.2050171 |
| median | 620.9300537 |
| Q3 | 1156.765015 |
| 95-th percentile | 2437.778076 |
| Maximum | 4053.559814 |
| Range | 4038.059814 |
| Interquartile range (IQR) | 843.5599976 |
Descriptive statistics
| Standard deviation | 739.3115845 |
|---|---|
| Coefficient of variation (CV) | 0.8981951461 |
| Kurtosis | 3.058235645 |
| Mean | 823.1079712 |
| Median Absolute Deviation (MAD) | 553.1356201 |
| Skewness | 1.625657439 |
| Sum | 110296.4609 |
| Variance | 546581.625 |
| Value | Count | Frequency (%) | |
| 496 | 2 | 0.2% | |
| 93 | 2 | 0.2% | |
| 310 | 2 | 0.2% | |
| 322.3999939 | 2 | 0.2% | |
| 589 | 2 | 0.2% | |
| 110.1600037 | 1 | 0.1% | |
| 194.8499908 | 1 | 0.1% | |
| 4053.559814 | 1 | 0.1% | |
| 899 | 1 | 0.1% | |
| 1194.73999 | 1 | 0.1% | |
| Other values (119) | 119 | 11.9% | |
| (Missing) | 866 | 86.6% |
| Value | Count | Frequency (%) | |
| 15.5 | 1 | 0.1% | |
| 37.61159897 | 1 | 0.1% | |
| 46.81800461 | 1 | 0.1% | |
| 47.09340286 | 1 | 0.1% | |
| 55.08000183 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 4053.559814 | 1 | 0.1% | |
| 3241.359863 | 1 | 0.1% | |
| 2892.919922 | 1 | 0.1% | |
| 2745.359863 | 1 | 0.1% | |
| 2628.800049 | 1 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| df_index | Linie | Richtung | Anzahl_Haltestellen | Haltestelle_Id | Nachste_Haltestelle_Id | Uhrzeit | Anzahl_Messungen | Einsteiger | Aussteiger | Besetzung | Distanz | Tage_DTV | Tage_DWV | Tage_SA | Tage_SO | Haltestelle | Haltestelle_Nummer | Nachste_Haltestelle | Nachste_Haltestelle_Nummer | Durchschnitt_Tag | Durchschnitt_Wochentag | Durchschnitt_Samstag | Durchschnitt_Sonntag | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 18651 | 13 | 1 | 9 | 441 | 440 | 1900-01-01 15:12:24 | NaN | 5.75 | 2.75 | 39.500000 | 450.0 | NaN | NaN | NaN | NaN | Zürich, Waidfussweg | 2800.0 | Zürich, Wipkingerplatz | 2937.0 | NaN | NaN | NaN | NaN |
| 1 | 60080 | 17 | 1 | 1 | 586 | 585 | 1900-01-01 19:09:30 | 2.0 | 1.50 | NaN | 1.500000 | 299.0 | 52.000000 | NaN | 52.0 | NaN | Zürich, Werdhölzli | 2872.0 | Zürich, Bändliweg | 592.0 | 78.000000 | NaN | 78.000000 | NaN |
| 2 | 46272 | 2 | 1 | 24 | 168 | 216 | 1900-01-01 14:38:06 | 3.0 | 15.33 | 20.33 | 49.330002 | 250.0 | 13.840000 | 13.840000 | NaN | NaN | Zürich, Bellevue | 440.0 | Zürich, Opernhaus | 1845.0 | 682.727234 | 682.727234 | NaN | NaN |
| 3 | 33646 | 31 | 1 | 28 | 118 | 119 | 1900-01-01 17:55:48 | 2.0 | NaN | 7.50 | 27.500000 | 320.0 | 20.299999 | 20.299999 | NaN | NaN | Zürich, Berghaldenstrasse | 455.0 | Zürich, Loorenstrasse | 1584.0 | 558.250000 | 558.250000 | NaN | NaN |
| 4 | 97055 | 14 | 1 | 23 | 185 | 186 | 1900-01-01 08:39:42 | 12.0 | 3.33 | 3.50 | 14.500000 | 339.0 | 62.000000 | NaN | NaN | 62.0 | Zürich, Goldbrunnenplatz | 1012.0 | Zürich, Talwiesenstrasse | 2638.0 | 899.000000 | NaN | NaN | 899.0 |
| 5 | 50738 | 2 | 1 | 24 | 168 | 216 | 1900-01-01 13:15:36 | 1.0 | 27.00 | 25.00 | 62.000000 | 250.0 | NaN | NaN | NaN | NaN | Zürich, Bellevue | 440.0 | Zürich, Opernhaus | 1845.0 | NaN | NaN | NaN | NaN |
| 6 | 65777 | 17 | 1 | 13 | 178 | 177 | 1900-01-01 11:23:48 | 5.0 | 11.00 | 12.20 | 44.599998 | 367.0 | 48.000000 | 48.000000 | NaN | NaN | Zürich, Limmatplatz | 1557.0 | Zürich, Museum für Gestaltung | 1667.0 | 2140.799805 | 2140.799805 | NaN | NaN |
| 7 | 44358 | 70 | 2 | 3 | 601 | 600 | 1900-01-01 18:12:36 | 10.0 | 1.00 | NaN | 10.900000 | 310.0 | 52.000000 | NaN | 52.0 | NaN | Zürich, Im Hüsli | 1310.0 | Zürich, Marbachweg | 1615.0 | 566.799988 | NaN | 566.799988 | NaN |
| 8 | 53266 | 80 | 2 | 7 | 143 | 142 | 1900-01-01 19:29:42 | 25.0 | 2.48 | 1.60 | 13.600000 | 430.0 | 203.000000 | 203.000000 | NaN | NaN | Zürich, Untermoosstrasse | 2754.0 | Zürich, Rautistrasse | 2034.0 | 2760.800049 | 2760.800049 | NaN | NaN |
| 9 | 65941 | 78 | 1 | 3 | 540 | 541 | 1900-01-01 16:25:06 | 15.0 | 5.46 | 0.20 | 11.130000 | 438.0 | 52.000000 | NaN | 52.0 | NaN | Zürich, Rautihalde | 2033.0 | Zürich, Schulhaus Buchlern | 2276.0 | 578.760010 | NaN | 578.760010 | NaN |
Last rows
| df_index | Linie | Richtung | Anzahl_Haltestellen | Haltestelle_Id | Nachste_Haltestelle_Id | Uhrzeit | Anzahl_Messungen | Einsteiger | Aussteiger | Besetzung | Distanz | Tage_DTV | Tage_DWV | Tage_SA | Tage_SO | Haltestelle | Haltestelle_Nummer | Nachste_Haltestelle | Nachste_Haltestelle_Nummer | Durchschnitt_Tag | Durchschnitt_Wochentag | Durchschnitt_Samstag | Durchschnitt_Sonntag | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990 | 89623 | 31 | 2 | 1 | 121 | 120 | 1900-01-01 05:37:00 | 6.0 | 3.16 | NaN | 3.160000 | 299.0 | 27.690001 | 27.690001 | NaN | NaN | Zürich, Kienastenwies | 1389.0 | Zürich, Zweiackerstrasse | 3011.0 | 87.500404 | 87.500404 | NaN | NaN |
| 991 | 7329 | 418 | 2 | 4 | 173 | 175 | 1900-01-01 17:54:54 | 23.0 | 3.39 | 13.91 | 120.040001 | 806.0 | 48.000000 | 48.000000 | NaN | NaN | Zürich, Balgrist | 421.0 | Zürich, Rehalp | 2549.0 | 5761.919922 | 5761.919922 | NaN | NaN |
| 992 | 98234 | 31 | 1 | 17 | 105 | 106 | 1900-01-01 18:43:54 | 2.0 | 1.00 | 0.50 | 35.500000 | 274.0 | 29.430000 | NaN | 29.430000 | NaN | Zürich, Neumarkt | 1724.0 | Zürich, Kunsthaus | 1472.0 | 1044.765015 | NaN | 1044.765015 | NaN |
| 993 | 3818 | 305 | 1 | 9 | 765 | 766 | 1900-01-01 08:33:48 | 10.0 | 0.10 | 0.60 | 2.700000 | 638.0 | 251.000000 | 251.000000 | NaN | NaN | Bergdietikon, Vorbühl | 2789.0 | Kindhausen AG, Eichholz | 757.0 | 677.700012 | 677.700012 | NaN | NaN |
| 994 | 20455 | 4 | 2 | 5 | 209 | 210 | 1900-01-01 05:23:36 | 47.0 | 0.10 | 0.12 | 1.820000 | 282.0 | 203.000000 | 203.000000 | NaN | NaN | Zürich, Sportweg | 2449.0 | Zürich, Aargauerstrasse | 7.0 | 369.460022 | 369.460022 | NaN | NaN |
| 995 | 19245 | 32 | 1 | 21 | 607 | 608 | 1900-01-01 14:25:54 | 16.0 | 2.87 | 3.81 | 21.620001 | 413.0 | 77.570000 | 77.570000 | NaN | NaN | Zürich, Höfliweg | 1272.0 | Zürich, Friesenberg | 902.0 | 1677.063477 | 1677.063477 | NaN | NaN |
| 996 | 53691 | 2 | 1 | 14 | 81 | 229 | 1900-01-01 23:59:48 | 1.0 | NaN | NaN | 2.000000 | 312.0 | NaN | NaN | NaN | NaN | Zürich, Albisriederplatz | 48.0 | Zürich, Zypressenstrasse | 3019.0 | NaN | NaN | NaN | NaN |
| 997 | 25429 | 33 | 1 | 20 | 87 | 74 | 1900-01-01 22:19:12 | 7.0 | 0.14 | 0.71 | 15.000000 | 243.0 | 20.299999 | 20.299999 | NaN | NaN | Zürich, Nürenbergstrasse | 1753.0 | Zürich, Bahnhof Wipkingen | 3043.0 | 304.500000 | 304.500000 | NaN | NaN |
| 998 | 39791 | 75 | 1 | 12 | 49 | 50 | 1900-01-01 16:13:00 | 9.0 | 1.77 | 2.77 | 26.440001 | 432.0 | 31.389999 | NaN | 31.389999 | NaN | Zürich, Bollingerweg | 3789.0 | Zürich, Max-Bill-Platz | 3764.0 | 829.951599 | NaN | 829.951599 | NaN |
| 999 | 66557 | 743 | 2 | 2 | 477 | 476 | 1900-01-01 09:00:54 | 15.0 | 1.00 | NaN | 1.730000 | 393.0 | 62.000000 | NaN | NaN | 62.0 | Maur, Kirche | 1403.0 | Maur, Dorf | 678.0 | 107.260002 | NaN | NaN | 107.260002 |